create procedure [dbo].[BAEOrderSuperProductChildProductInsert] @OrderProductID as
int,
    @ProductCode AS varchar(64),
    @DefaultForPrice AS bit,
    @Title AS varchar(128)
AS
    INSERT INTO OrderSuperProductChildProduct
    (    
    OrderProductID,            
    ProductCode,            
    DefaultForPrice,                
    Title        
    )
    VALUES
    (    
    @OrderProductID,            
    @ProductCode,            
    @DefaultForPrice,                
    @Title                                                                    
    );

    SELECT CAST(@@IDENTITY AS int) AS 'InsertedorderSuperProductChildProduct';

GO